using System;
using System.Data;
using System.Collections.Generic;
namespace eTMS.DAO{
	/********************************BEGIN DanhSachBaoLuuDAO****************************************/
	///<summary>
	/// <para>Author: Auto generated class by CSharp Code Generator v2.0</para>
	/// <para>Date:15/12/2011 05:01:08</para>
	/// <para>Class Name: DanhSachBaoLuuDAO</para>
	/// <para>Description: Class access to table DanhSachBaoLuu in database. Class for coder code here</para>
	///</summary>

	
	public partial class DanhSachBaoLuuDAO{
        public DataSet SelectAllDSSinhVienBaoLuu()
        {
            IDbCommand cmd = this.CreateCommand();
            cmd.CommandText = @"SELECT        SinhVien.SinhVien_ID, SinhVien.MaSinhVien, SinhVien.TenSinhVien, SinhVien.DiaChi, SinhVien.Email, SinhVien.SoCMND, SinhVien.DienThoai, SinhVien.GhiChu, 
                         SinhVien.GioiTinh, SinhVien.NgaySinh, DanhSachBaoLuu.DanhSachBaoLuu_ID, DanhSachBaoLuu.SinhVien_ID AS Expr1, DanhSachBaoLuu.NamHoc_ID, 
                         DanhSachBaoLuu.HocKy_ID, DanhSachBaoLuu.Lop_ID, DanhSachBaoLuu.NganhHoc_ID, DanhSachBaoLuu.NgayBaoLuu, DanhSachBaoLuu.ThoiHanBaoLuu, 
                         Lop.MaLop, Lop.TenLop, NganhHoc.MaNganhHoc, NganhHoc.TenNganhHoc, NamHoc.MaNamHoc, NamHoc.TenNamHoc, HocKy.MaHocKy, HocKy.TenHocKy
FROM            DanhSachBaoLuu INNER JOIN
                         SinhVien ON DanhSachBaoLuu.SinhVien_ID = SinhVien.SinhVien_ID INNER JOIN
                         HocKy ON DanhSachBaoLuu.HocKy_ID = HocKy.HocKy_ID INNER JOIN
                         NamHoc ON DanhSachBaoLuu.NamHoc_ID = NamHoc.NamHoc_ID INNER JOIN
                         NganhHoc ON DanhSachBaoLuu.NganhHoc_ID = NganhHoc.NganhHoc_ID INNER JOIN
                         Lop ON DanhSachBaoLuu.Lop_ID = Lop.Lop_ID";
            return this.SelectDS(cmd);
        }

	}
	/*****************************************************************************************************/
	/**********************************END DanhSachBaoLuuDAO*****************************************/
	/*****************************************************************************************************/
}

